Adding dynamic filters to queries

You can dynamically filter your query results using the variables described below.

Note: You must enter the quotation marks where indicated when using the following variables.

■    Filter by ContactKey and UserKey properties of a business object:

□    "@LoggedInUser" and "@Me": Both filter by the currently logged in user.

□    "@SelectedUser" and "@SubjectContact": Filters by a selected contact, such as contacts selected through On-Behalf-Of or user impersonation.  These variables also honor ContactKeys sent via URL parameters. For example, set NetContact.ContactKey equal to "@SelectedUser".

■    Filter by ID:

□    “@SelectedID”: For authenticated users, this variable filters by a selected ID, such as contacts selected through On-Behalf-Of, user impersonation, or ID’s sent via URL parameters. For example, set CsContact.ID equal to “@SelectedID”.

■    Filter by date properties:

□    @Date: Filters by the current date.

□    @Now: Filters by the current date and time.